/**
 * <p>Copyright (c) 2017 深圳市鹏途交通科技有限公司 </p>
 * <p>				   All right reserved. 		     </p>
 * 
 * <p>项目名称 ： 	深圳市国省检日常化监管系统         </p>
 * <p>创建者   :	win7 
 * 
 * <p>描   述  :   BuildingEffectsDao.java for com.pengtu.gsj.dao.yh    </p>
 * 
 * <p>最后修改 : $: Aug 31, 2017-3:50:15 PM v 1.0.0	 win7   $ </p>
 * 
*/

package com.pengtu.gsj.dao.yh;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.pengtu.gsj.dao.hibernate.HibernateDao;
import com.pengtu.gsj.entity.yh.BuildingEffects;

/**
 * 
 * BuildingEffectsDao
 * 
 * Aug 31, 2017 3:50:15 PM
 * 
 * @version 1.0.0
 * 
 */
@Repository
public class BuildingEffectsDao extends HibernateDao<BuildingEffects, String>{
	
	public List<BuildingEffects> getAllBuildingEffects(){
		String hql = "select new com.pengtu.gsj.entity.yh.BuildingEffects (t.id, t.roadName) from BuildingEffects t where t.delFlag='0' group by t.id, t.roadName order by t.roadName desc";
		return this.find(hql);
	}
}
